CREATE TABLE part1 (name TEXT, code TEXT);
CREATE TABLE part2 (name TEXT, code TEXT);
CREATE TABLE part3 (name TEXT, code TEXT);

-- 插入数据
INSERT INTO part1 (name, code) VALUES ('类别A', 'a');
INSERT INTO part1 (name, code) VALUES ('类别B', 'b');

INSERT INTO part2 (name, code) VALUES ('子类别1', '01');
INSERT INTO part2 (name, code) VALUES ('子类别2', '02');

INSERT INTO part3 (name, code) VALUES ('详细类别1', 'abcdefghi');
INSERT INTO part3 (name, code) VALUES ('详细类别2', 'jklmnopqr');